﻿	CREATE SET TABLE EDWEN.ACC_LIST ,FALLBACK ,
	     NO BEFORE JOURNAL,
	     NO AFTER JOURNAL,
	     CHECKSUM = DEFAULT
	     (
	      ADDR_ID INTEGER,
	      SFH_ID CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ,
	      TRAC_ID CHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC,
	      STREET_NUM VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
	      STREET_NAME VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
	      UNIT_NUM VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
	      CITY VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
	      STATE_CD CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('AL','FL','GA','KY','LA','MS','NC','SC','TN'),
	      ZIP_1_5_CD CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
	      ACTIVE CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT 'N' COMPRESS ('N','Y'),
	      PMASTER_ADDR_ID INTEGER,
	      ELU_ID VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
	      BAN VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
	      WIRE_CTR_CD CHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT '        ' COMPRESS '        ',
	      LUID VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
	      DA_CD VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC)
	UNIQUE PRIMARY INDEX ( ADDR_ID );


	CREATE SET TABLE EDWEN.stateLIST ,FALLBACK ,
	     NO BEFORE JOURNAL,
	     NO AFTER JOURNAL,
	     CHECKSUM = DEFAULT
	     (
	      STATE_NM VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
	      STATE_CD CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
	      REGION_CD CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC)
	UNIQUE PRIMARY INDEX ( STATE_CD );

